package com.ruoyi.spot.openapi.quotesTicker.mapper;

import java.util.List;

import com.ruoyi.spot.openapi.orderbook.domain.VO.SpotOpenapiOrderbookVO;
import com.ruoyi.spot.openapi.quotesTicker.domain.SpotOpenapiQuotesTicker;
import com.ruoyi.spot.openapi.quotesTicker.domain.VO.SpotOpenapiQuotesTickerVO;
import org.apache.ibatis.annotations.Param;

/**
 * 行情TickerMapper接口
 * 
 * @author saumell
 * @date 2024-08-09
 */
public interface SpotOpenapiQuotesTickerMapper 
{
    /**
     * 查询行情Ticker
     * 
     * @param id 行情Ticker主键
     * @return 行情Ticker
     */
    public SpotOpenapiQuotesTickerVO selectSpotOpenapiQuotesTickerById(Integer id);

    /**
     * 查询行情Ticker列表
     * 
     * @param spotOpenapiQuotesTicker 行情Ticker
     * @return 行情Ticker集合
     */
    public List<SpotOpenapiQuotesTickerVO> selectSpotOpenapiQuotesTickerList(SpotOpenapiQuotesTickerVO spotOpenapiQuotesTicker);

    /**
     * 新增行情Ticker
     * 
     * @param spotOpenapiQuotesTicker 行情Ticker
     * @return 结果
     */
    public int insertSpotOpenapiQuotesTicker(SpotOpenapiQuotesTicker spotOpenapiQuotesTicker);

    /**
     * 修改行情Ticker
     * 
     * @param spotOpenapiQuotesTicker 行情Ticker
     * @return 结果
     */
    public int updateSpotOpenapiQuotesTicker(SpotOpenapiQuotesTicker spotOpenapiQuotesTicker);

    /**
     * 删除行情Ticker
     * 
     * @param id 行情Ticker主键
     * @return 结果
     */
    public int deleteSpotOpenapiQuotesTickerById(Integer id);

    /**
     * 批量删除行情Ticker
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSpotOpenapiQuotesTickerByIds(Integer[] ids);
    List<SpotOpenapiQuotesTickerVO> selectSpotAllData();

    Integer queryCurryNumber(@Param("currencyPair")String currencyPair);
}
